The source of this article: http://www.cnblogs.com/wy123/p/6704619.htmlIssue backgroundIn a write SQL Server stored procedure, if a temporary table is defined in the stored procedure,Some people are used to explicitly delete a temporary table
Differences between Oracle temporary tables and SQL Server temporary tables:
The process of creating a temporary table in the Oracle database and the difference between the temporary table and the SQL Server are described in this article, next,
Differences between temporary tables in Oracle and temporary tables in SQL Server compared with the process of creating temporary tables in Oracle databases and the differences between temporary tables in SQL Server are the main content of this
This articleArticleThis article mainly introduces the usage of temporary tables in Oracle databases, hoping to help you learn and work.
I. Syntax
In Oracle, you can create two types of temporary tables:
(1) Session-specific temporary tables
The primary purpose of a temporary tablespace is to sort operations in a database [such as creating indexes, orders by and group BY, DISTINCT, union/intersect/minus/, sort-merge and join, analyze commands], managing indexes [ such as the creation of
Although we often use temporary tables in daily database development and maintenance, we may still have a poor understanding of temporary tables.
I found a good post on the Internet today to share with you.
Source:
1 Overview
In addition to permanent tables, the ORACLE database can also create temporary tables. These temporary tables are used to save the data of a SESSION or the data required in a transaction. When the session exits or the user commits a
1. Seven temporary filesThe content is organized from http://sqlite.org/tempfiles.html.A different feature of SQLite is that a database consists of a single disk file. This simplifies the use of SQLite, because you only need to copy a single file to
This article mainly introduces the Oracle database of temporary table usage, I hope to be helpful to everyone's study and work.One: GrammarIn Oracle, you can create the following two types of temporary tables:(1) session-specific temporary
Temporary tables: Like normal tables, there is a structure, but the management of the data is not the same, the temporary table stores the transaction or the intermediate result set of the session, the data saved in the temporary table is only
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.